Transformations and Filters

Click the Transformations and Filters tab to show the Expression defaults tab. Expressions can be used in global transformations and filter rules as well as in table-level transformations and filters.

This option can be set globally for all tasks or individually for a specific task. To set the option for a specific task, click the Change to Task Policy button and set the option as required. If you want to use the global policy set in the server settings'Transformations and Filters tab, click the Change to Global Policy button.

Support special characters in column names used in expressions: Enable this option if you want to include source column names with special characters in expressions defined for this task. An example of such a column name would be special#column.

A condition for enabling this option is that all table and global transformations must use strict SQL syntax. Specifically, all string literals must use single quotes (') rather than double quotes. If any of the transformations on any task on the server uses double quotes (") to quote literals, then you should not enable this option.

Before enabling this option, you must fix any use of double quotes in string literals. For example, a transformation such as:

CASE age WHEN age < 18 THEN "adult" ELSE "minor" END)

must be rewritten as:

CASE age WHEN age < 18 THEN 'adult' ELSE 'minor' END)

Learn more

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here